2016-02-09 - 24758 - Service Request - Mexico e-Invoice Customer Material (Dan by 2016-02-12) #ProductionBreakFix #Billing #ABAPEXTRACT

2016-02-09 - 24758 - Service Request - Mexico e-Invoice Customer Material

Problem Summary

---

The Customer Material ID is not showing in the Mexico e-Invoice extract if the schedule line does not match between the sales order and invoice.

Admin Info

---

Purpose	The Customer Material ID is not showing in the Mexico e-Invoice extract if the schedule line does not match between the sales order and invoice.
Requested by	Daniel Brennan
Issue Date	02-09-2016
Resolved by	Damodhier/Deepak yasam
Resolved Date	02-10-2016
Document Status	Completed

Detailed Problem Description

(Include Screen Shots if required )

---

The schedule line number (J_3AETENR) of the invoice is not matching with that of sales order and this is the reason for not displaying the KDMAT field into the extract.

Solution Analysis and Recommendations

(Include Screen Shots if required)

---

Need to change the logic to display the KDMAT value based on the UPC instead of J_3AETENR.

Resolution

---

Modified ETI extract program (ZISD_ETI_INVOICE_EXTRACT), to consider additional relationship, i.e., UPC (instead of the schedule line number) between the tables VBEP (J_3AEAN11) and VBRP (EAN11) to fetch the Customer Material (J_3AKDMAT).

Release Information

---

Provide link here to Release Notes if Technical Objects were changed

SD-Deepak-Damodar - 2016-02-11 - 24758 - Rel Notes - Mexico e-Invoice Customer Material